﻿        'T800作成
        MySQL = "SELECT
    NULL AS GPLEランク,
    NULL AS GPLIランク,
    T200.出荷先,
    T200.[アイテム],
    T200.G行,
    T200.Gバ,
    T200.Gケ,
    T200.GPL,
    T200.G容,
    T200.G重
FROM
    (
        T710_全出荷E判定
        INNER JOIN T200 ON T710_全出荷E判定.出荷先 = T200.出荷先
    )
    INNER JOIN T710_全出荷I集計 ON T200.[アイテム] = T710_全出荷I集計.[アイテム]
WHERE
    (
        ((T710_全出荷E判定.判定) = ’Yes’)
        AND ((T710_全出荷I集計.判定) = ’Yes’)
    );SELECT
    NULL AS GPLEランク,
    NULL AS GPLIランク,
    T200.出荷先,
    T200.[アイテム],
    T200.G行,
    T200.Gバ,
    T200.Gケ,
    T200.GPL,
    T200.G容,
    T200.G重
FROM
    (
        T710_全出荷E判定
        INNER JOIN T200 ON T710_全出荷E判定.出荷先 = T200.出荷先
    )
    INNER JOIN T710_全出荷I集計 ON T200.[アイテム] = T710_全出荷I集計.[アイテム]
WHERE
    (
        ((T710_全出荷E判定.判定) = ’Yes’)
        AND ((T710_全出荷I集計.判定) = ’Yes’)
    );"
            SQL実行(MySQL)
    End Sub
